USE DB_TCC
IF EXISTS(SELECT 1 FROM SYSOBJECTS WHERE NAME LIKE 'P_EXPERIENCIA_LISTAR')
	DROP PROCEDURE P_EXPERIENCIA_LISTAR
GO
CREATE PROCEDURE P_EXPERIENCIA_LISTAR(
	@IDCURRICULO INTEGER)
AS BEGIN
	SELECT
		IDEXPERIENCIA,
		IDCURRICULO,
		PAIS,
		UF,
		PORTE,
		SEGMENTO,
		CARGO,
		DESCATIVIDADES,
		DTINICIO,
		DTFIM,
		DTHRINCLUSAO,
		DTHRALTERACAO
	FROM
		EXPERIENCIA
	WHERE
		IDCURRICULO = @IDCURRICULO
END